<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %> 
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Int'l SEMATECH Manufacturing Initiative: Accelerating Manufacturing Productivity</title>

<!--[if IE]><script type="text/javascript" src="/includes/fix_eolas.js" defer="defer"></script><![endif]-->
<script>
    
    </script>

<style type="text/css">
.offscreen { 
  position: absolute; 
  top: -30em; 
  left: -300em; 
} 

div#vmenu { margin: 0; padding: .25em 0em .25em 0em; border: solid 1px #30c9e0; background: #0D5A8E; width: 20em; } 
div#vmenu ul { margin: 0; padding: 0; list-style: none; } 
div#vmenu ul li { margin: 0; padding: 0; list-style: none; } 
div#vmenu ul a:link { margin: 0; padding: .2em 0em .2em .4em; text-decoration: none; font-weight: bold; font-size: medium; background-color:#0D5A8E; color: #FFFFFF; display: block; } 
div#vmenu ul a:active { margin: 0; padding: .25em .5em .25em .5em; text-decoration: none; font-weight: bold; font-size: medium; background: yellow; color: #320000; display: block; } 
div#vmenu ul a:visited { margin: 0; padding: .25em .5em .25em .5em; text-decoration: none; font-weight: bold; font-size: medium; background:#0D5A8E; color: #ffffff; display: block; } 
div#vmenu ul li a:hover { margin: 0; padding: .2em 0em .2em .4em; text-decoration: none; font-weight: bold; font-size: medium; background-color:#80AACB; color: #ffffff; display: block; 
}
</style>

<link href="public.css" rel="stylesheet" type="text/css" />

<link href="dropdown.css" rel="stylesheet" type="text/css" />

<link href="override.css" rel="stylesheet" type="text/css" /> 


</head>

<body>

<div id="container">

        <div id="utilityRow">
   		<div id="utilityLinks">

		<p><a href="http://www.sematech.org">SEMATECH</a>&nbsp;&nbsp;|&nbsp;&nbsp;
                    <a href="https://www.sematech.org">Login to Member Site</a>&nbsp;&nbsp;|&nbsp;&nbsp;
                    <a href="http://ismi.sematech.org/corporate/contact.htm">Contact Us</a>&nbsp;&nbsp;|&nbsp;&nbsp;
                    <a href="/sitemap.htm">Site Map</a>&nbsp;&nbsp;|&nbsp;&nbsp;
                    <a href="LoginPage.jsp" >Login to Ebay</a>
                 </p>
                </div>	

 	</div>

  <!-- end of utilityRow -->
 <table id="headerRowHomeISMI" >
                <tr>
                    <td id="logoHome"><img src="ISMI.jpg" alt="ISMI Logo" width="275" height="150" border="0" /></td>
                    <td id="feature"><img src="ismi_design_cube.jpg"  width="703" height="150" border="0"/> </td>
   	
                </tr>
</table>
  <div id="menuRow">
  	<!-- ****************BEGIN MAIN NAVIGATION**************** --> 
    <div id="menu">
       
        <form action="searcher" method="post"> 
       <input name="query" type="text" align="left"  size="70"/>
       <input type="submit"  name="Go" value="Search"  ></input>
       </form>
        
    </div>
	<!-- ****************END MAIN NAVIGATION**************** -->
  </div>
  <h2 class="offscreen">W3C Web Resources</h2> 
<div id="vmenu"> 
<ul> 
  <li><a href="http://www.onsemi.com/PowerSolutions/parametrics.do?id=2146">Crystal Oscillators</a></li>
  <li><a href="http://www.onsemi.com/PowerSolutions/parametrics.do?id=480">Phase Detectors</a></li>
  <li><a href="http://www.onsemi.com/PowerSolutions/parametrics.do?id=827">Tuning Diodes</a></li>
  <li><a href="http://www.onsemi.com/PowerSolutions/parametrics.do?id=149">Converters</a></li>
  <li><a href="http://www.onsemi.com/PowerSolutions/parametrics.do?id=145">Controllers</a></li>
  <li><a href="http://www.onsemi.com/PowerSolutions/parametrics.do?id=246">Logic Gates</a></li>
  <li><a href="http://www.onsemi.com/PowerSolutions/parametrics.do?id=669">VCO's</a></li>
  <li><a href="http://www.onsemi.com/PowerSolutions/parametrics.do?id=976">Off-line Controllers</a></li>
  <li><a href="http://www.onsemi.com/PowerSolutions/parametrics.do?id=449">Off-line Regulators</a></li>
  <li><a href="http://www.onsemi.com/PowerSolutions/parametrics.do?id=981">Power Factor Controllers</a></li>
  <li><a href="http://www.onsemi.com/PowerSolutions/parametrics.do?id=145">Controllers</a></li>
  <li><a href="http://www.onsemi.com/PowerSolutions/parametrics.do?id=197">LED Drivers</a></li>
  <li><a href="http://www.onsemi.com/PowerSolutions/parametrics.do?id=358">Relay Drivers</a></li>
  <li><a href="http://www.onsemi.com/PowerSolutions/parametrics.do?id=407">Motor Drivers</a></li>  
</ul>   
</div> 
  
  <div id="subsidiariesHome">

<center>

<p style="font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:bold; margin: 10px 0px 10px 0px; color:#999;"> ISMI News Network 

  on&nbsp;&nbsp;</p>

<a href="http://www.linkedin.com/groups?gid=3896787" title="ISMI News Network on LinkedIn" target="_blank"><img src="linkedin.jpg" alt="Follow ISMI News Network on LinkedIn" width="104" height="30" border="0" /></a>

</center>

&nbsp;<br />

&nbsp;<br />



<center>

&nbsp;

<p><br />

<a class="SKSFlash" href="http://ismi.sematech.org/meetings/sks.htm?utm_source=LG&utm_medium=PW&utm_content=Flash&utm_campaign=SKS"><IMG src="knowlseries.jpg" width="150" height="120" border="0"></a>

</p>

</center>

    </div>



  </div>

  <!-- end of bottomRowHome -->
  
  
   
</div>
<%
try {
/* Create string of connection url within specified format with machine
name, port number and database name. Here machine name id localhost and 
database name is student. */
String connectionURL = "jdbc:mysql://localhost:3306/ismi";
// declare a connection by using Connection interface
Connection connection = null;
/* declare object of Statement interface that is used for executing sql 
statements. */
Statement statement = null;
// declare a resultset that uses as a table for output data from tha table.
ResultSet rs = null;
// Load JBBC driver "com.mysql.jdbc.Driver"
Class.forName("com.mysql.jdbc.Driver").newInstance();
/* Create a connection by using getConnection() method that takes parameters 
of string type connection url, user name and password to connect to database.*/
connection = DriverManager.getConnection(connectionURL, "root", "isaac16");
/* createStatement() is used for create statement object that is used for 
sending sql statements to the specified database. */
statement = connection.createStatement();
String s = request.getParameter("query");

PreparedStatement selectProduct = null;
            
selectProduct = connection.prepareStatement("SELECT * FROM product where"
                    +" product_name=?");
            
selectProduct.setString(1, s);
            
rs = selectProduct.executeQuery();

%>
<div id="bottomRowHome">
    <div id="bottomCenterHome">
      <div id="contentHome">
             <div id="events">
<TABLE cellpadding="15" border="1" style="background-color: #ffffcc;">
<%
while (rs.next()) {
%>
<TR>
<TD><%=rs.getInt(1)%></TD>
<TD><%=rs.getString(2)%></TD>
<TD><%=rs.getString(3)%></TD>
<TD><%=rs.getString(7)%></TD>
</TR>
<% } %>
<%
// close all the connections.
rs.close();
statement.close();
connection.close();
} catch (Exception ex) {
%>
</font>
<font size="+3" color="red"/></b>
<%
out.println("Unable to connect to database.");
}
%>

</table>
</div>
</div>
</div>
</div>
</body>

</html>
